semicolon(;),33,179–180
sequences
ofclauses,117
collationsequences,278–280
ofevaluation,59–61,80
ServerProperty()function,279
SETIDENTITY_INSERTstatement,177
SETstatement,186,215–216
settingup
accessrights,291–292
full-textsearching
full-textcatalogs,163–166
full-textindexes,164–166
full-textsearchsupport,162–163
Sin()function,94
sines,returning,94
singlequotes(’),53,169,220
singlevalues,checkingagainst,51–52
sortingcombinedqueryresults,158–159
sortingdata
inascendingorder,46–47
casesensitivityand,46
indescendingorder,44–46
dictionarysortorder,46
groupingversussorting,114–116
bymultiplecolumns,43–44
bysinglecolumn,41–43
Soundex()function,85–86
sp_columnsstoredprocedure,27–28
sp_databasesstoredprocedure,26
sp_fulltext_databasestoredprocedure,162–163
sp_helploginsstoredprocedure,28,289
SP_HELPTRIGGERstoredprocedure,250
sp_helpuserstoredprocedure,28
sp_renamestoredprocedure,201